In [ ]:
%run "../Static data/English localization.ipynb"
In [ ]:
# Options that don't need translations are commented out
# The first translated element is the correct answer when applicable
# Options that are deprecated are listed last
yesNoIdontknowTranslation = {
"Oui" : "Yes",
"Non" : "No",
"Je ne sais pas" : "I don't know",
}
interestTranslation = {
"Beaucoup" : "A lot",
"Enormément" : "Extremely",
"Moyennement" : "Moderately",
"Un peu" : "Slightly",
"Pas du tout" : "Not at all",
"Je ne sais pas" : "I don't know",
}
gameInterestTranslation = interestTranslation
gameFrequencyTranslation = {
"Beaucoup" : "A lot",
"Enormément" : "Extremely",
"Moyennement" : "Moderately",
"Un peu" : "Rarely",
"Pas du tout" : "Not at all",
"Je ne sais pas" : "I don't know",
}
genderTranslation = {
"Femme" : "Female",
"Homme" : "Male",
"Autre" : "Other",
"Je ne souhaite pas le préciser" : "Prefer not to say",
}
biologyStudyTranslation = {
"Jamais, pas même au collège" : "Not even in middle school",
"Jusqu'au brevet" : "Until the end of middle school",
"Jusqu'au bac" : "Until the end of high school",
"Jusqu'à la license" : "Until bachelor's degree",
"Au moins jusqu'au master" : "At least until master's degree",
"Je ne sais pas" : "I don't know",
#"Jamais" : "Never", # no occurrence of "Never" in the responses
"Jamais" : "Not even in middle school",
}
biologyInterestTranslation = interestTranslation
previousPlayTranslation = {
"De nombreuses fois" : "Multiple times",
"Quelques fois" : "A few times",
"Une fois" : "Once",
"Oui" : "Yes",
"Non" : "No",
"Je ne sais pas" : "I don't know",
}
Q1AnswersTranslation = {
"Modifier l'ADN de la bactérie" : "Edit the DNA of the bacterium",
"Ramasser des nanorobots" : "Gather nanobots",
"Faire bouger la bactérie" : "Move the bacterium",
"Diviser la bactérie" : "Divide the bacterium",
"Je ne sais pas" : "I don't know",
"Injecter des molécules" : "Inject molecules",
}
Q2AnswersTranslation = {
"Des séquences d'ADN" : "DNA sequences",
"Des séquences d'ARN" : "RNA sequences",
"Des acides aminés" : "Amino-acids",
"Des protéines" : "Proteins",
"Des gènes" : "Genes",
"Je ne sais pas" : "I don't know",
}
Q3AnswersTranslation = {
"Terminateur" : "Terminator",
"Transposeur" : "Trespasser",
"Transcripteur" : "Transcriptor",
"Translator" : "Trieur",
"Je ne sais pas" : "I don't know",
}
Q4AnswersTranslation = {
"Promoteur" : "Promoter",
"Prémoteur" : "Protomer",
"Précurseur" : "Precursor",
"Procuror" : "Procureur",
"Je ne sais pas" : "I don't know",
}
Q5AnswersTranslation = {
"Séquence Codante" : "Coding Sequence",
#"Ribosome",
"Protéine" : "Protein",
#"Fluorescence",
"Je ne sais pas" : "I don't know",
}
Q6AnswersTranslation = {
#"RBS",
#"ATP",
#"GFP",
#"PCR",
"Je ne sais pas" : "I don't know",
}
biobrickFunctionTranslation = {
"Elle indique la fin de la construction" : "It shows the end of the device",
"Elle contrôle quand la construction est active" : "It controls when the device is active",
"Elle contrôle quelle protéine est produite, et donc quelle capacité est affectée" : "It controls which protein is produced, and thus which ability is affected",
"Elle contrôle le niveau d'expression, et donc à quel point la capacité est affectée" : "It controls the level of expression, and thus how much the ability will be affected",
"Je ne sais pas" : "I don't know",
"Elle contrôle quelle capacité est affectée, en codant quelle protéine est produite par la contruction" : "It controls which protein is produced, and thus which ability is affected",
}
Q7AnswersTranslation = biobrickFunctionTranslation
Q8AnswersTranslation = biobrickFunctionTranslation
Q9AnswersTranslation = biobrickFunctionTranslation
Q10AnswersTranslation = biobrickFunctionTranslation
# Could not be fixed directly in the Google form, unfortunately
Q11AnswersTranslation = {
"Option 1" : "Option 3",
#"Option 2"
"Option 3" : "Option 1",
#"Option 4"
"Je ne sais pas" : "I don't know",
}
Q12AnswersTranslation = {
"Sous lumière bleue, quand la construction GFP est équipée" : "Under blue light, when the GFP device is equipped",
"Sous lumière bleue, tout le temps" : "Under blue light, all the time",
"Devant les portes, quand la construction GFP est équipée" : "In front of the doors, when the GFP device is equipped",
"Devant les portes, tout le temps" : "In front of the doors, all the time",
"Je ne sais pas" : "I don't know",
}
Q13AnswersTranslation = {
"Les flagelles disparaissent l'un après l'autre, rapidement" : "Flagella quickly disappear one by one",
"La bactérie devient lumineuse" : "The bacterium glows",
"La bactérie meurt" : "The bacterium dies",
"Rien" : "Nothing",
"Je ne sais pas" : "I don't know",
}
Q14AnswersTranslation = {
"Un plasmide - un moyen d'équiper une construction supplémentaire" : "A plasmid - it makes it possible to equip an additional device",
"Une algue dans le décor du jeu" : "Algae from the game's scenery",
"Un nanorobot - simplement un bonus dans le jeu" : "A nanobot - a game bonus",
"Un promoteur induit, qui ne fonctionne que dans l'arabinose" : "An induced promoter, which works only in arabinose",
"Je ne sais pas" : "I don't know",
}
deviceFunctionTranslation = {
"Elle permet de se déplacer plus vite" : "It makes it possible to move faster",
"Elle produit la fluorescence verte" : "It generates green fluorescence",
"Elle produit la fluorescence verte en présence de l-arabinose" : "It generates green fluorescence in presence of l-arabinose",
"Elle permet de résister aux antibiotiques" : "It generates antibiotic resistance",
"Je ne sais pas" : "I don't know",
}
Q15AnswersTranslation = deviceFunctionTranslation
Q16AnswersTranslation = deviceFunctionTranslation
Q17AnswersTranslation = deviceFunctionTranslation
Q18AnswersTranslation = deviceFunctionTranslation
Q19AnswersTranslation = deviceFunctionTranslation
Q20AnswersTranslation = deviceFunctionTranslation
Q21AnswersTranslation = deviceFunctionTranslation
Q22AnswersTranslation = deviceFunctionTranslation
Q23AnswersTranslation = {
"A partir du moment où elle serait induite, elle produirait de plus en plus de l-arabinose puisqu'elle s'induirait elle-même" : "After being induced, it would produce more and more l-arabinose, because it would induce itself",
"Elle ne serait active que dans les nuages de l-arabinose" : "It would be active only in l-arabinose clouds",
"Elle produirait en permanence de la l-arabinose" : "It would produce l-arabinose all the time",
"Elle ne produirait rien puisqu'elle s'induit elle-même" : "It would produce nothing since it induces itself",
"Je ne sais pas" : "I don't know",
}
Q24AnswersTranslation = {
"Si elle produisait de la YFP sous lumière cyan" : "If it produced YFP under cyan light",
"Si elle produisait de la BFP sous lumière violette" : "If it produced BFP under purple light",
"Si elle produisait de la RFP sous lumière jaune" : "If it produced RFP under yellow light",
"Si elle produisait de la GFP sous lumière jaune" : "If it produced GFP under yellow light",
"Je ne sais pas" : "I don't know",
"Si elle produit de la BFP sous lumière violette" : "If it produced BFP under purple light",
"Si elle produit de la YFP sous lumière cyan" : "If it produced YFP under cyan light",
#"If it produces BFP under purple light"
#"If it produces YFP under cyan light"
}
Q25AnswersTranslation = {
#"E. Coli"
#"Hero.Coli"
"Nanorobot" : "Nanobot",
#"Cellia"
"Je ne sais pas" : "I don't know",
}
Q26AnswersTranslation = {
"Des flagelles" : "Flagella",
"Des nageoires" : "Fins",
"Des mitochondries" : "Mitochondria",
"Des plasmides" : "Plasmids",
"Je ne sais pas" : "I don't know",
}
Q27AnswersTranslation = {
"Ampicilline" : "Ampicillin",
#"Arabinose"
#"GFP"
"Terminateur" : "Terminator",
"Je ne sais pas" : "I don't know",
}
In [ ]:
questionsAnswersTranslationsFR = pd.Series(
[
# Timestamp
[], # 1
# Basic demographics questions
gameInterestTranslation, # 2
gameFrequencyTranslation, # 3
[], # 4
genderTranslation, # 5
# Basic biology questions
biologyStudyTranslation, # 6
biologyInterestTranslation, # 7
yesNoIdontknowTranslation, # 8
yesNoIdontknowTranslation, # 9
# Your experience with Hero.Coli
previousPlayTranslation, # 10
previousPlayTranslation, # 11
previousPlayTranslation, # 12
previousPlayTranslation, # 13
# General mechanics of the game
Q1AnswersTranslation, # 12
Q2AnswersTranslation, # 13
# BioBricks
Q3AnswersTranslation, # 16
Q4AnswersTranslation, # 17
Q5AnswersTranslation, # 18
Q6AnswersTranslation, # 19
# BioBrick functions
Q7AnswersTranslation, #20
Q8AnswersTranslation, #21
Q9AnswersTranslation, #22
Q10AnswersTranslation, #23
# Devices
Q11AnswersTranslation, #24
Q12AnswersTranslation, #25
Q13AnswersTranslation, #26
# Devices
Q14AnswersTranslation, #27
# Device symbols
Q15AnswersTranslation, #28
Q16AnswersTranslation, #29
Q17AnswersTranslation, #30
Q18AnswersTranslation, #31
# Device symbols
Q19AnswersTranslation, #32
Q20AnswersTranslation, #33
Q21AnswersTranslation, #34
Q22AnswersTranslation, #35
# Beyond the game
Q23AnswersTranslation, # 36
Q24AnswersTranslation, #37
Q25AnswersTranslation, #38
Q26AnswersTranslation, #39
Q27AnswersTranslation, #40
# Remarks
[], # 41
# ID
[], # 42
# Language
[], # 43
# Temporality
[], # 44
], index = gformEN.columns
)
#questionsAnswersTranslationsFR
#questionsAnswersTranslationsFR.loc['Are you interested in video games?']['Beaucoup']
In [ ]:
questionsAnswersTranslationsFR
In [ ]:
#questionsAnswersTranslationsFR.to_csv(frTranslationsPath, encoding=csvEncoding)
In [ ]:
correctAnswersFR = pd.Series(
[
# Timestamp
[], # 1
# Basic demographics questions
[], # 2
[], # 3
[], # 4
[], # 5
# Basic biology questions
[], # 6
[], # 7
[], # 8
[], # 9
# Your experience with Hero.Coli
[], # 10
[], # 11
[], # 12
[], # 13
# General mechanics of the game
["Modifier l"], #14
["Des séquences d'ADN"], #15
# BioBricks
["Terminateur"], #16
["Promoteur"], #17
["Séquence Codante"], #18
["RBS"], #19
# BioBrick functions
["Elle indique la fin de la construction"], #20
["Elle contrôle quand la construction est active"], #21
["Elle contrôle quelle protéine est produite, et donc quelle capacité est affectée"], #22
["Elle contrôle le niveau d"], #23
# Devices
["Option 3"], #24
["Sous lumière bleue, quand la construction GFP"], #25
["Les flagelles disparaissent l"], #26
# Devices
["Un plasmide - un moyen d"], #27
# Device symbols
["Elle produit la fluorescence verte"], #28
["Elle permet de se déplacer plus vite"], #29
["Elle permet de résister aux antibiotiques"], #30
["Elle produit la fluorescence verte en présence"], #31
# Device symbols
["Elle produit la fluorescence verte"], #32
["Elle permet de se déplacer plus vite"], #33
["Elle permet de résister aux antibiotiques"], #34
["Elle produit la fluorescence verte en présence"], #35
# Beyond the game
["A partir du moment où elle serait induite, elle"], #36
["Si elle produit de la YFP sous lumière cyan"], #37
["Des flagelles"], #38
["Ampicilline"], #39
["E. Coli"], #40
# Remarks
[], #41
# ID
[], #42
# Language
[], # 43
# Temporality
[], # 44
], index = gformEN.columns
)
#correctAnswersFR
In [ ]:
#correctAnswersFR.to_csv(frCorrectScientificAnswersPath, encoding=csvEncoding)
In [ ]:
interestPositives = ["Beaucoup","Enormément","Moyennement"]
gameInterestPositives = interestPositives
frequencyPositives = interestPositives
agePositives = [18,19,20,21,22,23]
genderPositives = ["Femme"]
biologyStudyPositives = ["Jusqu'à la license","Au moins jusqu'au master"]
biologyInterestPositives = interestPositives
yesNoIdontknowPositives = ["Oui"]
previousPlayPositives = ["De nombreuses fois","Quelques fois","Une fois","Oui"]
languagePositives = [enLanguageID]
temporalityPositives = [answerTemporalities[1]]
demographicAnswersFR = pd.Series(
[
# Timestamp
[], #1
# Basic demographics questions
interestPositives, #2
frequencyPositives, #3
agePositives, #4
genderPositives, #5
# Basic biology questions
biologyStudyPositives, #6
biologyInterestPositives, #7
yesNoIdontknowPositives, #8
yesNoIdontknowPositives, #9
# Your experience with Hero.Coli
previousPlayPositives, #10
previousPlayPositives, #11
previousPlayPositives, #12
previousPlayPositives, #13
# General mechanics of the game
[], #14
[], #15
# BioBricks
[], #16
[], #17
[], #18
[], #19
# BioBrick functions
[], #20
[], #21
[], #22
[], #23
# Devices
[], #24
[], #25
[], #26
# Devices
[], #27
# Device symbols
[], #28
[], #29
[], #30
[], #31
# Device symbols
[], #32
[], #33
[], #34
[], #35
# Beyond the game
[], #36
[], #37
[], #38
[], #39
[], #40
# Remarks
[], #41
# ID
[], #42
# Language
languagePositives, #43
# Temporality
temporalityPositives, #44
], index = gformEN.columns
)
#demographicAnswersFR
In [ ]:
#demographicAnswersFR.to_csv(frDemographicAnswersPath, encoding=csvEncoding)